Skip Headers

Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# BLANK_TRIMMING

Property | Description
--- | ---
Parameter type | Boolean
Default value | `false`
Modifiable | No
Range of values | `true | false`
Basic | No

`BLANK_TRIMMING` specifies the data assignment semantics of character datatypes.

Values:

- `TRUE`

  Allows the data assignment of a source character string or variable to a destination character column or variable even though the source length is longer than the destination length. In this case, however, the additional length over the destination length is all blanks. This value complies with the semantics of SQL92 Transitional Level and above.

- `FALSE`

  Disallows the data assignment if the source length is longer than the destination length and reverts to SQL92 Entry Level semantics.